#！/bin/bash 
source /etc/profile 
# 可以输入日期；如果未输入日期取昨天的时间 
if [ -n "$1" ] 
then
do_date=$1 
else
do_date=`date -d "-1 day" +%F` 
fi
# 定义要执行的SQL 

# 汇总得到每日活跃会员信息；每日数据汇总得到每周、每月数据 
sql=" insert overwrite table dws.dws_member_start_day partition(dt='$do_date') 
select uid, 
concat_ws('|', collect_set(device_id)), 
concat_ws('|', collect_set(app_v)), 
concat_ws('|', collect_set(os_type)), 
concat_ws('|', collect_set(language)), 
concat_ws('|', collect_set(channel)), 
concat_ws('|', collect_set(area)), 
concat_ws('|', collect_set(brand)) 
from dwd.dwd_start_log 
where dt='$do_date' 
group by device_id;
"

hive -e "$sql"